﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PadariaNovosTemposDataSet" targetNamespace="http://tempuri.org/PadariaNovosTemposDataSet.xsd" xmlns:mstns="http://tempuri.org/PadariaNovosTemposDataSet.xsd" xmlns="http://tempuri.org/PadariaNovosTemposDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PadariaNovosTemposConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="PadariaNovosTemposConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PadariaNovosTempos.My.MySettings.GlobalReference.Default.PadariaNovosTemposConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Cargo_FuncionarioTableAdapter" GeneratorDataComponentClassName="Cargo_FuncionarioTableAdapter" Name="Cargo_Funcionario" UserDataComponentName="Cargo_FuncionarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Cargo_Funcionario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Cargo_Funcionario] WHERE (([Cargo_ID] = @Original_Cargo_ID) AND ([Descrição] = @Original_Descrição))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrição" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Cargo_Funcionario] ([Cargo_ID], [Descrição]) VALUES (@Cargo_ID, @Descrição);
SELECT Cargo_ID, Descrição FROM Cargo_Funcionario WHERE (Cargo_ID = @Cargo_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrição" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Cargo_ID, Descrição FROM dbo.Cargo_Funcionario</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Cargo_Funcionario] SET [Cargo_ID] = @Cargo_ID, [Descrição] = @Descrição WHERE (([Cargo_ID] = @Original_Cargo_ID) AND ([Descrição] = @Original_Descrição));
SELECT Cargo_ID, Descrição FROM Cargo_Funcionario WHERE (Cargo_ID = @Cargo_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrição" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrição" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Cargo_ID" DataSetColumn="Cargo_ID" />
              <Mapping SourceColumn="Descrição" DataSetColumn="Descrição" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ComandaTableAdapter" GeneratorDataComponentClassName="ComandaTableAdapter" Name="Comanda" UserDataComponentName="ComandaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Comanda" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Comanda] WHERE (([ComandaID] = @Original_ComandaID) AND ([StatusID] = @Original_StatusID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ComandaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ComandaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Comanda] ([ComandaID], [StatusID]) VALUES (@ComandaID, @StatusID);
SELECT ComandaID, StatusID FROM Comanda WHERE (ComandaID = @ComandaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ComandaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ComandaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ComandaID, StatusID FROM dbo.Comanda</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Comanda] SET [ComandaID] = @ComandaID, [StatusID] = @StatusID WHERE (([ComandaID] = @Original_ComandaID) AND ([StatusID] = @Original_StatusID));
SELECT ComandaID, StatusID FROM Comanda WHERE (ComandaID = @ComandaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ComandaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ComandaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ComandaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ComandaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ComandaID" DataSetColumn="ComandaID" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EstadoTableAdapter" GeneratorDataComponentClassName="EstadoTableAdapter" Name="Estado" UserDataComponentName="EstadoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Estado" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Estado] WHERE (([Sigla] = @Original_Sigla) AND ([Descrição] = @Original_Descrição))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descrição" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Estado] ([Sigla], [Descrição]) VALUES (@Sigla, @Descrição);
SELECT Sigla, Descrição FROM Estado WHERE (Sigla = @Sigla)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descrição" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Sigla, Descrição FROM dbo.Estado</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Estado] SET [Sigla] = @Sigla, [Descrição] = @Descrição WHERE (([Sigla] = @Original_Sigla) AND ([Descrição] = @Original_Descrição));
SELECT Sigla, Descrição FROM Estado WHERE (Sigla = @Sigla)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descrição" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descrição" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descrição" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Sigla" DataSetColumn="Sigla" />
              <Mapping SourceColumn="Descrição" DataSetColumn="Descrição" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Formas_PagamentoTableAdapter" GeneratorDataComponentClassName="Formas_PagamentoTableAdapter" Name="Formas_Pagamento" UserDataComponentName="Formas_PagamentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Formas_Pagamento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Formas_Pagamento] WHERE (([FormasPagID] = @Original_FormasPagID) AND ([Descricao] = @Original_Descricao) AND ([Percentual] = @Original_Percentual) AND ((@IsNull_TipoPercentual = 1 AND [TipoPercentual] IS NULL) OR ([TipoPercentual] = @Original_TipoPercentual)) AND ((@IsNull_parametro01 = 1 AND [parametro01] IS NULL) OR ([parametro01] = @Original_parametro01)) AND ((@IsNull_parametro02 = 1 AND [parametro02] IS NULL) OR ([parametro02] = @Original_parametro02)) AND ((@IsNull_parametro03 = 1 AND [parametro03] IS NULL) OR ([parametro03] = @Original_parametro03)) AND ((@IsNull_parametro04 = 1 AND [parametro04] IS NULL) OR ([parametro04] = @Original_parametro04)) AND ((@IsNull_parametro05 = 1 AND [parametro05] IS NULL) OR ([parametro05] = @Original_parametro05)) AND ((@IsNull_parametro06 = 1 AND [parametro06] IS NULL) OR ([parametro06] = @Original_parametro06)) AND ((@IsNull_parametro07 = 1 AND [parametro07] IS NULL) OR ([parametro07] = @Original_parametro07)) AND ((@IsNull_parametro08 = 1 AND [parametro08] IS NULL) OR ([parametro08] = @Original_parametro08)) AND ((@IsNull_parametro09 = 1 AND [parametro09] IS NULL) OR ([parametro09] = @Original_parametro09)) AND ((@IsNull_parametro10 = 1 AND [parametro10] IS NULL) OR ([parametro10] = @Original_parametro10)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FormasPagID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FormasPagID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Percentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Percentual" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoPercentual" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoPercentual" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoPercentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoPercentual" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro01" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro01" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro01" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro01" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro02" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro02" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro02" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro02" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro03" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro03" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro03" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro03" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro04" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro04" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro04" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro04" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro05" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro05" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro05" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro05" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro06" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro06" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro06" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro06" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro07" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro07" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro07" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro07" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro08" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro08" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro08" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro08" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro09" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro09" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro09" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro09" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro10" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro10" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro10" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro10" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Formas_Pagamento] ([FormasPagID], [Descricao], [Percentual], [TipoPercentual], [parametro01], [parametro02], [parametro03], [parametro04], [parametro05], [parametro06], [parametro07], [parametro08], [parametro09], [parametro10]) VALUES (@FormasPagID, @Descricao, @Percentual, @TipoPercentual, @parametro01, @parametro02, @parametro03, @parametro04, @parametro05, @parametro06, @parametro07, @parametro08, @parametro09, @parametro10);
SELECT FormasPagID, Descricao, Percentual, TipoPercentual, parametro01, parametro02, parametro03, parametro04, parametro05, parametro06, parametro07, parametro08, parametro09, parametro10 FROM Formas_Pagamento WHERE (FormasPagID = @FormasPagID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FormasPagID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FormasPagID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Percentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Percentual" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoPercentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoPercentual" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro01" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro01" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro02" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro02" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro03" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro03" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro04" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro04" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro05" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro05" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro06" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro06" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro07" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro07" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro08" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro08" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro09" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro09" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro10" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro10" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT FormasPagID, Descricao, Percentual, TipoPercentual, parametro01, parametro02, parametro03, parametro04, parametro05, parametro06, parametro07, parametro08, parametro09, parametro10 FROM dbo.Formas_Pagamento</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Formas_Pagamento] SET [FormasPagID] = @FormasPagID, [Descricao] = @Descricao, [Percentual] = @Percentual, [TipoPercentual] = @TipoPercentual, [parametro01] = @parametro01, [parametro02] = @parametro02, [parametro03] = @parametro03, [parametro04] = @parametro04, [parametro05] = @parametro05, [parametro06] = @parametro06, [parametro07] = @parametro07, [parametro08] = @parametro08, [parametro09] = @parametro09, [parametro10] = @parametro10 WHERE (([FormasPagID] = @Original_FormasPagID) AND ([Descricao] = @Original_Descricao) AND ([Percentual] = @Original_Percentual) AND ((@IsNull_TipoPercentual = 1 AND [TipoPercentual] IS NULL) OR ([TipoPercentual] = @Original_TipoPercentual)) AND ((@IsNull_parametro01 = 1 AND [parametro01] IS NULL) OR ([parametro01] = @Original_parametro01)) AND ((@IsNull_parametro02 = 1 AND [parametro02] IS NULL) OR ([parametro02] = @Original_parametro02)) AND ((@IsNull_parametro03 = 1 AND [parametro03] IS NULL) OR ([parametro03] = @Original_parametro03)) AND ((@IsNull_parametro04 = 1 AND [parametro04] IS NULL) OR ([parametro04] = @Original_parametro04)) AND ((@IsNull_parametro05 = 1 AND [parametro05] IS NULL) OR ([parametro05] = @Original_parametro05)) AND ((@IsNull_parametro06 = 1 AND [parametro06] IS NULL) OR ([parametro06] = @Original_parametro06)) AND ((@IsNull_parametro07 = 1 AND [parametro07] IS NULL) OR ([parametro07] = @Original_parametro07)) AND ((@IsNull_parametro08 = 1 AND [parametro08] IS NULL) OR ([parametro08] = @Original_parametro08)) AND ((@IsNull_parametro09 = 1 AND [parametro09] IS NULL) OR ([parametro09] = @Original_parametro09)) AND ((@IsNull_parametro10 = 1 AND [parametro10] IS NULL) OR ([parametro10] = @Original_parametro10)));
SELECT FormasPagID, Descricao, Percentual, TipoPercentual, parametro01, parametro02, parametro03, parametro04, parametro05, parametro06, parametro07, parametro08, parametro09, parametro10 FROM Formas_Pagamento WHERE (FormasPagID = @FormasPagID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FormasPagID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FormasPagID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Percentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Percentual" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoPercentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoPercentual" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro01" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro01" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro02" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro02" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro03" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro03" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro04" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro04" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro05" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro05" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro06" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro06" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro07" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro07" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro08" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro08" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro09" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro09" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parametro10" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro10" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FormasPagID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FormasPagID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Percentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Percentual" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoPercentual" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoPercentual" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoPercentual" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoPercentual" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro01" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro01" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro01" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro01" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro02" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro02" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro02" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro02" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro03" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro03" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro03" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro03" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro04" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro04" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro04" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro04" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro05" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro05" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro05" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro05" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro06" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro06" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro06" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro06" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro07" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro07" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro07" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro07" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro08" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro08" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro08" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro08" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro09" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro09" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro09" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro09" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parametro10" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parametro10" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parametro10" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parametro10" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FormasPagID" DataSetColumn="FormasPagID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
              <Mapping SourceColumn="Percentual" DataSetColumn="Percentual" />
              <Mapping SourceColumn="TipoPercentual" DataSetColumn="TipoPercentual" />
              <Mapping SourceColumn="parametro01" DataSetColumn="parametro01" />
              <Mapping SourceColumn="parametro02" DataSetColumn="parametro02" />
              <Mapping SourceColumn="parametro03" DataSetColumn="parametro03" />
              <Mapping SourceColumn="parametro04" DataSetColumn="parametro04" />
              <Mapping SourceColumn="parametro05" DataSetColumn="parametro05" />
              <Mapping SourceColumn="parametro06" DataSetColumn="parametro06" />
              <Mapping SourceColumn="parametro07" DataSetColumn="parametro07" />
              <Mapping SourceColumn="parametro08" DataSetColumn="parametro08" />
              <Mapping SourceColumn="parametro09" DataSetColumn="parametro09" />
              <Mapping SourceColumn="parametro10" DataSetColumn="parametro10" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FornecedorTableAdapter" GeneratorDataComponentClassName="FornecedorTableAdapter" Name="Fornecedor" UserDataComponentName="FornecedorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Fornecedor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Fornecedor] WHERE (([FornecedorID] = @Original_FornecedorID) AND ([Nome] = @Original_Nome) AND ([Fantasia] = @Original_Fantasia) AND ([Cnpj] = @Original_Cnpj) AND ([Ie] = @Original_Ie) AND ([Endereco] = @Original_Endereco) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_Contato = 1 AND [Contato] IS NULL) OR ([Contato] = @Original_Contato)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)) AND ((@IsNull_Site = 1 AND [Site] IS NULL) OR ([Site] = @Original_Site)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FornecedorID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FornecedorID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Fornecedor] ([FornecedorID], [Nome], [Fantasia], [Cnpj], [Ie], [Endereco], [Cidade], [Bairro], [Cep], [UF], [Telefone], [Fax], [Contato], [E-mail], [Site]) VALUES (@FornecedorID, @Nome, @Fantasia, @Cnpj, @Ie, @Endereco, @Cidade, @Bairro, @Cep, @UF, @Telefone, @Fax, @Contato, @p1, @Site);
SELECT FornecedorID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, Contato, [E-mail], Site FROM Fornecedor WHERE (FornecedorID = @FornecedorID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FornecedorID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FornecedorID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT FornecedorID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, Contato, [E-mail], Site FROM dbo.Fornecedor</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Fornecedor] SET [FornecedorID] = @FornecedorID, [Nome] = @Nome, [Fantasia] = @Fantasia, [Cnpj] = @Cnpj, [Ie] = @Ie, [Endereco] = @Endereco, [Cidade] = @Cidade, [Bairro] = @Bairro, [Cep] = @Cep, [UF] = @UF, [Telefone] = @Telefone, [Fax] = @Fax, [Contato] = @Contato, [E-mail] = @p1, [Site] = @Site WHERE (([FornecedorID] = @Original_FornecedorID) AND ([Nome] = @Original_Nome) AND ([Fantasia] = @Original_Fantasia) AND ([Cnpj] = @Original_Cnpj) AND ([Ie] = @Original_Ie) AND ([Endereco] = @Original_Endereco) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_Contato = 1 AND [Contato] IS NULL) OR ([Contato] = @Original_Contato)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)) AND ((@IsNull_Site = 1 AND [Site] IS NULL) OR ([Site] = @Original_Site)));
SELECT FornecedorID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, Contato, [E-mail], Site FROM Fornecedor WHERE (FornecedorID = @FornecedorID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FornecedorID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FornecedorID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FornecedorID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FornecedorID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FornecedorID" DataSetColumn="FornecedorID" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Fantasia" DataSetColumn="Fantasia" />
              <Mapping SourceColumn="Cnpj" DataSetColumn="Cnpj" />
              <Mapping SourceColumn="Ie" DataSetColumn="Ie" />
              <Mapping SourceColumn="Endereco" DataSetColumn="Endereco" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="UF" DataSetColumn="UF" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="Contato" DataSetColumn="Contato" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
              <Mapping SourceColumn="Site" DataSetColumn="Site" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FuncionarioTableAdapter" GeneratorDataComponentClassName="FuncionarioTableAdapter" Name="Funcionario" UserDataComponentName="FuncionarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Funcionario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Funcionario] WHERE (([Func_ID] = @Original_Func_ID) AND ([Cargo_ID] = @Original_Cargo_ID) AND ([EmpresaID] = @Original_EmpresaID) AND ([Nome] = @Original_Nome) AND ([Endereço] = @Original_Endereço) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Func_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Func_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereço" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereço" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Funcionario] ([Func_ID], [Cargo_ID], [EmpresaID], [Nome], [Endereço], [Cidade], [Bairro], [Cep], [UF], [Telefone], [E-mail]) VALUES (@Func_ID, @Cargo_ID, @EmpresaID, @Nome, @Endereço, @Cidade, @Bairro, @Cep, @UF, @Telefone, @p1);
SELECT Func_ID, Cargo_ID, EmpresaID, Nome, Endereço, Cidade, Bairro, Cep, UF, Telefone, [E-mail] FROM Funcionario WHERE (Func_ID = @Func_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Func_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Func_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereço" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereço" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Func_ID, Cargo_ID, EmpresaID, Nome, Endereço, Cidade, Bairro, Cep, UF, Telefone, [E-mail] FROM dbo.Funcionario</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Funcionario] SET [Func_ID] = @Func_ID, [Cargo_ID] = @Cargo_ID, [EmpresaID] = @EmpresaID, [Nome] = @Nome, [Endereço] = @Endereço, [Cidade] = @Cidade, [Bairro] = @Bairro, [Cep] = @Cep, [UF] = @UF, [Telefone] = @Telefone, [E-mail] = @p1 WHERE (([Func_ID] = @Original_Func_ID) AND ([Cargo_ID] = @Original_Cargo_ID) AND ([EmpresaID] = @Original_EmpresaID) AND ([Nome] = @Original_Nome) AND ([Endereço] = @Original_Endereço) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)));
SELECT Func_ID, Cargo_ID, EmpresaID, Nome, Endereço, Cidade, Bairro, Cep, UF, Telefone, [E-mail] FROM Funcionario WHERE (Func_ID = @Func_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Func_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Func_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereço" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereço" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Func_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Func_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cargo_ID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cargo_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereço" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereço" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Func_ID" DataSetColumn="Func_ID" />
              <Mapping SourceColumn="Cargo_ID" DataSetColumn="Cargo_ID" />
              <Mapping SourceColumn="EmpresaID" DataSetColumn="EmpresaID" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Endereço" DataSetColumn="Endereço" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="UF" DataSetColumn="UF" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusTableAdapter" GeneratorDataComponentClassName="StatusTableAdapter" Name="Status" UserDataComponentName="StatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Status" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Status] WHERE (([StatusID] = @Original_StatusID) AND ([Descricao] = @Original_Descricao))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Status] ([StatusID], [Descricao]) VALUES (@StatusID, @Descricao);
SELECT StatusID, Descricao FROM Status WHERE (StatusID = @StatusID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT StatusID, Descricao FROM dbo.Status</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Status] SET [StatusID] = @StatusID, [Descricao] = @Descricao WHERE (([StatusID] = @Original_StatusID) AND ([Descricao] = @Original_Descricao));
SELECT StatusID, Descricao FROM Status WHERE (StatusID = @StatusID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_StatusID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClienteTableAdapter" GeneratorDataComponentClassName="ClienteTableAdapter" Name="Cliente" UserDataComponentName="ClienteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Cliente" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Cliente] WHERE (([ClienteID] = @Original_ClienteID) AND ([Nome] = @Original_Nome) AND ([Fantasia] = @Original_Fantasia) AND ([Cnpj] = @Original_Cnpj) AND ([Ie] = @Original_Ie) AND ([Endereco] = @Original_Endereco) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_Contato = 1 AND [Contato] IS NULL) OR ([Contato] = @Original_Contato)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)) AND ((@IsNull_Site = 1 AND [Site] IS NULL) OR ([Site] = @Original_Site)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ClienteID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ClienteID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Cliente] ([Nome], [Fantasia], [Cnpj], [Ie], [Endereco], [Cidade], [Bairro], [Cep], [UF], [Telefone], [Fax], [Contato], [E-mail], [Site]) VALUES (@Nome, @Fantasia, @Cnpj, @Ie, @Endereco, @Cidade, @Bairro, @Cep, @UF, @Telefone, @Fax, @Contato, @p1, @Site);
SELECT ClienteID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, Contato, [E-mail], Site FROM Cliente WHERE (ClienteID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ClienteID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, Contato, [E-mail], Site
FROM         Cliente</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Cliente] SET [Nome] = @Nome, [Fantasia] = @Fantasia, [Cnpj] = @Cnpj, [Ie] = @Ie, [Endereco] = @Endereco, [Cidade] = @Cidade, [Bairro] = @Bairro, [Cep] = @Cep, [UF] = @UF, [Telefone] = @Telefone, [Fax] = @Fax, [Contato] = @Contato, [E-mail] = @p1, [Site] = @Site WHERE (([ClienteID] = @Original_ClienteID) AND ([Nome] = @Original_Nome) AND ([Fantasia] = @Original_Fantasia) AND ([Cnpj] = @Original_Cnpj) AND ([Ie] = @Original_Ie) AND ([Endereco] = @Original_Endereco) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_Contato = 1 AND [Contato] IS NULL) OR ([Contato] = @Original_Contato)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)) AND ((@IsNull_Site = 1 AND [Site] IS NULL) OR ([Site] = @Original_Site)));
SELECT ClienteID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, Contato, [E-mail], Site FROM Cliente WHERE (ClienteID = @ClienteID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ClienteID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ClienteID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contato" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ClienteID" ColumnName="ClienteID" DataSourceName="PadariaNovosTempos.dbo.Cliente" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@ClienteID" Precision="4" ProviderType="Decimal" Scale="0" Size="5" SourceColumn="ClienteID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ClienteID" DataSetColumn="ClienteID" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Fantasia" DataSetColumn="Fantasia" />
              <Mapping SourceColumn="Cnpj" DataSetColumn="Cnpj" />
              <Mapping SourceColumn="Ie" DataSetColumn="Ie" />
              <Mapping SourceColumn="Endereco" DataSetColumn="Endereco" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="UF" DataSetColumn="UF" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="Contato" DataSetColumn="Contato" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
              <Mapping SourceColumn="Site" DataSetColumn="Site" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GrupoTableAdapter" GeneratorDataComponentClassName="GrupoTableAdapter" Name="Grupo" UserDataComponentName="GrupoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Grupo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Grupo] WHERE (([GrupoID] = @Original_GrupoID) AND ([Descricao] = @Original_Descricao))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="GrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Grupo] ([Descricao]) VALUES (@Descricao);
SELECT GrupoID, Descricao FROM Grupo WHERE (GrupoID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     GrupoID, Descricao
FROM         Grupo</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Grupo] SET [Descricao] = @Descricao WHERE (([GrupoID] = @Original_GrupoID) AND ([Descricao] = @Original_Descricao));
SELECT GrupoID, Descricao FROM Grupo WHERE (GrupoID = @GrupoID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="GrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="GrupoID" ColumnName="GrupoID" DataSourceName="PadariaNovosTempos.dbo.Grupo" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@GrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="5" SourceColumn="GrupoID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GrupoID" DataSetColumn="GrupoID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubGrupoTableAdapter" GeneratorDataComponentClassName="SubGrupoTableAdapter" Name="SubGrupo" UserDataComponentName="SubGrupoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.SubGrupo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [SubGrupo] WHERE (([subGrupoID] = @Original_subGrupoID) AND ([Descricao] = @Original_Descricao))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_subGrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="subGrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [SubGrupo] ([Descricao]) VALUES (@Descricao);
SELECT subGrupoID, Descricao FROM SubGrupo WHERE (subGrupoID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     subGrupoID, Descricao
FROM         SubGrupo</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [SubGrupo] SET [Descricao] = @Descricao WHERE (([subGrupoID] = @Original_subGrupoID) AND ([Descricao] = @Original_Descricao));
SELECT subGrupoID, Descricao FROM SubGrupo WHERE (subGrupoID = @subGrupoID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_subGrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="subGrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="subGrupoID" ColumnName="subGrupoID" DataSourceName="PadariaNovosTempos.dbo.SubGrupo" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@subGrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="5" SourceColumn="subGrupoID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="subGrupoID" DataSetColumn="subGrupoID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Unidade_MedidaTableAdapter" GeneratorDataComponentClassName="Unidade_MedidaTableAdapter" Name="Unidade_Medida" UserDataComponentName="Unidade_MedidaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Unidade_Medida" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Unidade_Medida] WHERE (([UniMedidaID] = @Original_UniMedidaID) AND ([Descricao] = @Original_Descricao))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Unidade_Medida] ([UniMedidaID], [Descricao]) VALUES (@UniMedidaID, @Descricao);
SELECT UniMedidaID, Descricao FROM Unidade_Medida WHERE (UniMedidaID = @UniMedidaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UniMedidaID, Descricao
FROM         Unidade_Medida</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Unidade_Medida] SET [UniMedidaID] = @UniMedidaID, [Descricao] = @Descricao WHERE (([UniMedidaID] = @Original_UniMedidaID) AND ([Descricao] = @Original_Descricao));
SELECT UniMedidaID, Descricao FROM Unidade_Medida WHERE (UniMedidaID = @UniMedidaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UniMedidaID" DataSetColumn="UniMedidaID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProdutoTableAdapter" GeneratorDataComponentClassName="ProdutoTableAdapter" Name="Produto" UserDataComponentName="ProdutoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Produto" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Produto] WHERE (([ProdutoID] = @Original_ProdutoID) AND ([Codigo_Barras] = @Original_Codigo_Barras) AND ([GrupoID] = @Original_GrupoID) AND ([subGrupoID] = @Original_subGrupoID) AND ([UniMedidaID] = @Original_UniMedidaID) AND ([Descricao] = @Original_Descricao) AND ([Qtde] = @Original_Qtde) AND ([Estoque_Minimo] = @Original_Estoque_Minimo) AND ([precoCusto] = @Original_precoCusto) AND ([precoVenda] = @Original_precoVenda) AND ([EmpresaID] = @Original_EmpresaID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProdutoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ProdutoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Codigo_Barras" Precision="30" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Codigo_Barras" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="GrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_subGrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="subGrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Qtde" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Qtde" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Estoque_Minimo" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Estoque_Minimo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_precoCusto" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoCusto" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_precoVenda" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoVenda" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Produto] ([Codigo_Barras], [GrupoID], [subGrupoID], [UniMedidaID], [Descricao], [Qtde], [Estoque_Minimo], [precoCusto], [precoVenda], [EmpresaID]) VALUES (@Codigo_Barras, @GrupoID, @subGrupoID, @UniMedidaID, @Descricao, @Qtde, @Estoque_Minimo, @precoCusto, @precoVenda, @EmpresaID);
SELECT ProdutoID, Codigo_Barras, GrupoID, subGrupoID, UniMedidaID, Descricao, Qtde, Estoque_Minimo, precoCusto, precoVenda, EmpresaID FROM Produto WHERE (ProdutoID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Codigo_Barras" Precision="30" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Codigo_Barras" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="GrupoID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@subGrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="subGrupoID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Qtde" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Qtde" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Estoque_Minimo" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Estoque_Minimo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@precoCusto" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoCusto" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@precoVenda" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoVenda" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ProdutoID, Codigo_Barras, GrupoID, subGrupoID, UniMedidaID, Descricao, Qtde, Estoque_Minimo, precoCusto, precoVenda, EmpresaID
FROM         Produto</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Produto] SET [Codigo_Barras] = @Codigo_Barras, [GrupoID] = @GrupoID, [subGrupoID] = @subGrupoID, [UniMedidaID] = @UniMedidaID, [Descricao] = @Descricao, [Qtde] = @Qtde, [Estoque_Minimo] = @Estoque_Minimo, [precoCusto] = @precoCusto, [precoVenda] = @precoVenda, [EmpresaID] = @EmpresaID WHERE (([ProdutoID] = @Original_ProdutoID) AND ([Codigo_Barras] = @Original_Codigo_Barras) AND ([GrupoID] = @Original_GrupoID) AND ([subGrupoID] = @Original_subGrupoID) AND ([UniMedidaID] = @Original_UniMedidaID) AND ([Descricao] = @Original_Descricao) AND ([Qtde] = @Original_Qtde) AND ([Estoque_Minimo] = @Original_Estoque_Minimo) AND ([precoCusto] = @Original_precoCusto) AND ([precoVenda] = @Original_precoVenda) AND ([EmpresaID] = @Original_EmpresaID));
SELECT ProdutoID, Codigo_Barras, GrupoID, subGrupoID, UniMedidaID, Descricao, Qtde, Estoque_Minimo, precoCusto, precoVenda, EmpresaID FROM Produto WHERE (ProdutoID = @ProdutoID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Codigo_Barras" Precision="30" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Codigo_Barras" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="GrupoID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@subGrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="subGrupoID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Qtde" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Qtde" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Estoque_Minimo" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Estoque_Minimo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@precoCusto" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoCusto" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@precoVenda" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoVenda" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProdutoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="ProdutoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Codigo_Barras" Precision="30" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Codigo_Barras" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="GrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_subGrupoID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="subGrupoID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniMedidaID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniMedidaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Qtde" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Qtde" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Estoque_Minimo" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Estoque_Minimo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_precoCusto" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoCusto" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_precoVenda" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="precoVenda" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ProdutoID" ColumnName="ProdutoID" DataSourceName="PadariaNovosTempos.dbo.Produto" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@ProdutoID" Precision="4" ProviderType="Decimal" Scale="0" Size="5" SourceColumn="ProdutoID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProdutoID" DataSetColumn="ProdutoID" />
              <Mapping SourceColumn="Codigo_Barras" DataSetColumn="Codigo_Barras" />
              <Mapping SourceColumn="GrupoID" DataSetColumn="GrupoID" />
              <Mapping SourceColumn="subGrupoID" DataSetColumn="subGrupoID" />
              <Mapping SourceColumn="UniMedidaID" DataSetColumn="UniMedidaID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
              <Mapping SourceColumn="Qtde" DataSetColumn="Qtde" />
              <Mapping SourceColumn="Estoque_Minimo" DataSetColumn="Estoque_Minimo" />
              <Mapping SourceColumn="precoCusto" DataSetColumn="precoCusto" />
              <Mapping SourceColumn="precoVenda" DataSetColumn="precoVenda" />
              <Mapping SourceColumn="EmpresaID" DataSetColumn="EmpresaID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmpresaTableAdapter" GeneratorDataComponentClassName="EmpresaTableAdapter" Name="Empresa" UserDataComponentName="EmpresaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PadariaNovosTemposConnectionString (MySettings)" DbObjectName="PadariaNovosTempos.dbo.Empresa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Empresa] WHERE (([EmpresaID] = @Original_EmpresaID) AND ([Nome] = @Original_Nome) AND ([Fantasia] = @Original_Fantasia) AND ([Cnpj] = @Original_Cnpj) AND ([Ie] = @Original_Ie) AND ([Endereco] = @Original_Endereco) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)) AND ((@IsNull_Site = 1 AND [Site] IS NULL) OR ([Site] = @Original_Site)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Empresa] ([Nome], [Fantasia], [Cnpj], [Ie], [Endereco], [Cidade], [Bairro], [Cep], [UF], [Telefone], [Fax], [E-mail], [Site]) VALUES (@Nome, @Fantasia, @Cnpj, @Ie, @Endereco, @Cidade, @Bairro, @Cep, @UF, @Telefone, @Fax, @p1, @Site);
SELECT EmpresaID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, [E-mail], Site FROM Empresa WHERE (EmpresaID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     EmpresaID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, [E-mail], Site
FROM         Empresa</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Empresa] SET [Nome] = @Nome, [Fantasia] = @Fantasia, [Cnpj] = @Cnpj, [Ie] = @Ie, [Endereco] = @Endereco, [Cidade] = @Cidade, [Bairro] = @Bairro, [Cep] = @Cep, [UF] = @UF, [Telefone] = @Telefone, [Fax] = @Fax, [E-mail] = @p1, [Site] = @Site WHERE (([EmpresaID] = @Original_EmpresaID) AND ([Nome] = @Original_Nome) AND ([Fantasia] = @Original_Fantasia) AND ([Cnpj] = @Original_Cnpj) AND ([Ie] = @Original_Ie) AND ([Endereco] = @Original_Endereco) AND ([Cidade] = @Original_Cidade) AND ([Bairro] = @Original_Bairro) AND ([Cep] = @Original_Cep) AND ([UF] = @Original_UF) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@p3 = 1 AND [E-mail] IS NULL) OR ([E-mail] = @p2)) AND ((@IsNull_Site = 1 AND [Site] IS NULL) OR ([Site] = @Original_Site)));
SELECT EmpresaID, Nome, Fantasia, Cnpj, Ie, Endereco, Cidade, Bairro, Cep, UF, Telefone, Fax, [E-mail], Site FROM Empresa WHERE (EmpresaID = @EmpresaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fantasia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fantasia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnpj" Precision="12" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ie" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Endereco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Endereco" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cep" Precision="8" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UF" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Telefone" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Fax" Precision="11" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Site" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Site" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="EmpresaID" ColumnName="EmpresaID" DataSourceName="PadariaNovosTempos.dbo.Empresa" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@EmpresaID" Precision="4" ProviderType="Decimal" Scale="0" Size="5" SourceColumn="EmpresaID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EmpresaID" DataSetColumn="EmpresaID" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Fantasia" DataSetColumn="Fantasia" />
              <Mapping SourceColumn="Cnpj" DataSetColumn="Cnpj" />
              <Mapping SourceColumn="Ie" DataSetColumn="Ie" />
              <Mapping SourceColumn="Endereco" DataSetColumn="Endereco" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="UF" DataSetColumn="UF" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
              <Mapping SourceColumn="Site" DataSetColumn="Site" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PadariaNovosTemposDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="PadariaNovosTemposDataSet" msprop:Generator_DataSetName="PadariaNovosTemposDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cargo_Funcionario" msprop:Generator_UserTableName="Cargo_Funcionario" msprop:Generator_RowDeletedName="Cargo_FuncionarioRowDeleted" msprop:Generator_RowChangedName="Cargo_FuncionarioRowChanged" msprop:Generator_RowClassName="Cargo_FuncionarioRow" msprop:Generator_RowChangingName="Cargo_FuncionarioRowChanging" msprop:Generator_RowEvArgName="Cargo_FuncionarioRowChangeEvent" msprop:Generator_RowEvHandlerName="Cargo_FuncionarioRowChangeEventHandler" msprop:Generator_TableClassName="Cargo_FuncionarioDataTable" msprop:Generator_TableVarName="tableCargo_Funcionario" msprop:Generator_RowDeletingName="Cargo_FuncionarioRowDeleting" msprop:Generator_TablePropName="Cargo_Funcionario">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Cargo_ID" msprop:Generator_UserColumnName="Cargo_ID" msprop:Generator_ColumnPropNameInRow="Cargo_ID" msprop:Generator_ColumnVarNameInTable="columnCargo_ID" msprop:Generator_ColumnPropNameInTable="Cargo_IDColumn" type="xs:decimal" />
              <xs:element name="Descrição" msprop:Generator_UserColumnName="Descrição" msprop:Generator_ColumnPropNameInRow="Descrição" msprop:Generator_ColumnVarNameInTable="columnDescrição" msprop:Generator_ColumnPropNameInTable="DescriçãoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Comanda" msprop:Generator_UserTableName="Comanda" msprop:Generator_RowDeletedName="ComandaRowDeleted" msprop:Generator_RowChangedName="ComandaRowChanged" msprop:Generator_RowClassName="ComandaRow" msprop:Generator_RowChangingName="ComandaRowChanging" msprop:Generator_RowEvArgName="ComandaRowChangeEvent" msprop:Generator_RowEvHandlerName="ComandaRowChangeEventHandler" msprop:Generator_TableClassName="ComandaDataTable" msprop:Generator_TableVarName="tableComanda" msprop:Generator_RowDeletingName="ComandaRowDeleting" msprop:Generator_TablePropName="Comanda">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ComandaID" msprop:Generator_UserColumnName="ComandaID" msprop:Generator_ColumnPropNameInRow="ComandaID" msprop:Generator_ColumnVarNameInTable="columnComandaID" msprop:Generator_ColumnPropNameInTable="ComandaIDColumn" type="xs:decimal" />
              <xs:element name="StatusID" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Estado" msprop:Generator_UserTableName="Estado" msprop:Generator_RowDeletedName="EstadoRowDeleted" msprop:Generator_RowChangedName="EstadoRowChanged" msprop:Generator_RowClassName="EstadoRow" msprop:Generator_RowChangingName="EstadoRowChanging" msprop:Generator_RowEvArgName="EstadoRowChangeEvent" msprop:Generator_RowEvHandlerName="EstadoRowChangeEventHandler" msprop:Generator_TableClassName="EstadoDataTable" msprop:Generator_TableVarName="tableEstado" msprop:Generator_RowDeletingName="EstadoRowDeleting" msprop:Generator_TablePropName="Estado">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Sigla" msprop:Generator_UserColumnName="Sigla" msprop:Generator_ColumnPropNameInRow="Sigla" msprop:Generator_ColumnVarNameInTable="columnSigla" msprop:Generator_ColumnPropNameInTable="SiglaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descrição" msprop:Generator_UserColumnName="Descrição" msprop:Generator_ColumnPropNameInRow="Descrição" msprop:Generator_ColumnVarNameInTable="columnDescrição" msprop:Generator_ColumnPropNameInTable="DescriçãoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Formas_Pagamento" msprop:Generator_UserTableName="Formas_Pagamento" msprop:Generator_RowDeletedName="Formas_PagamentoRowDeleted" msprop:Generator_RowChangedName="Formas_PagamentoRowChanged" msprop:Generator_RowClassName="Formas_PagamentoRow" msprop:Generator_RowChangingName="Formas_PagamentoRowChanging" msprop:Generator_RowEvArgName="Formas_PagamentoRowChangeEvent" msprop:Generator_RowEvHandlerName="Formas_PagamentoRowChangeEventHandler" msprop:Generator_TableClassName="Formas_PagamentoDataTable" msprop:Generator_TableVarName="tableFormas_Pagamento" msprop:Generator_RowDeletingName="Formas_PagamentoRowDeleting" msprop:Generator_TablePropName="Formas_Pagamento">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FormasPagID" msprop:Generator_UserColumnName="FormasPagID" msprop:Generator_ColumnPropNameInRow="FormasPagID" msprop:Generator_ColumnVarNameInTable="columnFormasPagID" msprop:Generator_ColumnPropNameInTable="FormasPagIDColumn" type="xs:decimal" />
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Percentual" msprop:Generator_UserColumnName="Percentual" msprop:Generator_ColumnPropNameInRow="Percentual" msprop:Generator_ColumnVarNameInTable="columnPercentual" msprop:Generator_ColumnPropNameInTable="PercentualColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipoPercentual" msprop:Generator_UserColumnName="TipoPercentual" msprop:Generator_ColumnPropNameInRow="TipoPercentual" msprop:Generator_ColumnVarNameInTable="columnTipoPercentual" msprop:Generator_ColumnPropNameInTable="TipoPercentualColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro01" msprop:Generator_UserColumnName="parametro01" msprop:Generator_ColumnPropNameInRow="parametro01" msprop:Generator_ColumnVarNameInTable="columnparametro01" msprop:Generator_ColumnPropNameInTable="parametro01Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro02" msprop:Generator_UserColumnName="parametro02" msprop:Generator_ColumnPropNameInRow="parametro02" msprop:Generator_ColumnVarNameInTable="columnparametro02" msprop:Generator_ColumnPropNameInTable="parametro02Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro03" msprop:Generator_UserColumnName="parametro03" msprop:Generator_ColumnPropNameInRow="parametro03" msprop:Generator_ColumnVarNameInTable="columnparametro03" msprop:Generator_ColumnPropNameInTable="parametro03Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro04" msprop:Generator_UserColumnName="parametro04" msprop:Generator_ColumnPropNameInRow="parametro04" msprop:Generator_ColumnVarNameInTable="columnparametro04" msprop:Generator_ColumnPropNameInTable="parametro04Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro05" msprop:Generator_UserColumnName="parametro05" msprop:Generator_ColumnPropNameInRow="parametro05" msprop:Generator_ColumnVarNameInTable="columnparametro05" msprop:Generator_ColumnPropNameInTable="parametro05Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro06" msprop:Generator_UserColumnName="parametro06" msprop:Generator_ColumnPropNameInRow="parametro06" msprop:Generator_ColumnVarNameInTable="columnparametro06" msprop:Generator_ColumnPropNameInTable="parametro06Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro07" msprop:Generator_UserColumnName="parametro07" msprop:Generator_ColumnPropNameInRow="parametro07" msprop:Generator_ColumnVarNameInTable="columnparametro07" msprop:Generator_ColumnPropNameInTable="parametro07Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro08" msprop:Generator_UserColumnName="parametro08" msprop:Generator_ColumnPropNameInRow="parametro08" msprop:Generator_ColumnVarNameInTable="columnparametro08" msprop:Generator_ColumnPropNameInTable="parametro08Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro09" msprop:Generator_UserColumnName="parametro09" msprop:Generator_ColumnPropNameInRow="parametro09" msprop:Generator_ColumnVarNameInTable="columnparametro09" msprop:Generator_ColumnPropNameInTable="parametro09Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parametro10" msprop:Generator_UserColumnName="parametro10" msprop:Generator_ColumnPropNameInRow="parametro10" msprop:Generator_ColumnVarNameInTable="columnparametro10" msprop:Generator_ColumnPropNameInTable="parametro10Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Fornecedor" msprop:Generator_UserTableName="Fornecedor" msprop:Generator_RowDeletedName="FornecedorRowDeleted" msprop:Generator_RowChangedName="FornecedorRowChanged" msprop:Generator_RowClassName="FornecedorRow" msprop:Generator_RowChangingName="FornecedorRowChanging" msprop:Generator_RowEvArgName="FornecedorRowChangeEvent" msprop:Generator_RowEvHandlerName="FornecedorRowChangeEventHandler" msprop:Generator_TableClassName="FornecedorDataTable" msprop:Generator_TableVarName="tableFornecedor" msprop:Generator_RowDeletingName="FornecedorRowDeleting" msprop:Generator_TablePropName="Fornecedor">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FornecedorID" msprop:Generator_UserColumnName="FornecedorID" msprop:Generator_ColumnPropNameInRow="FornecedorID" msprop:Generator_ColumnVarNameInTable="columnFornecedorID" msprop:Generator_ColumnPropNameInTable="FornecedorIDColumn" type="xs:decimal" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fantasia" msprop:Generator_UserColumnName="Fantasia" msprop:Generator_ColumnPropNameInRow="Fantasia" msprop:Generator_ColumnVarNameInTable="columnFantasia" msprop:Generator_ColumnPropNameInTable="FantasiaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnpj" msprop:Generator_UserColumnName="Cnpj" msprop:Generator_ColumnPropNameInRow="Cnpj" msprop:Generator_ColumnVarNameInTable="columnCnpj" msprop:Generator_ColumnPropNameInTable="CnpjColumn" type="xs:decimal" />
              <xs:element name="Ie" msprop:Generator_UserColumnName="Ie" msprop:Generator_ColumnPropNameInRow="Ie" msprop:Generator_ColumnVarNameInTable="columnIe" msprop:Generator_ColumnPropNameInTable="IeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Endereco" msprop:Generator_UserColumnName="Endereco" msprop:Generator_ColumnPropNameInRow="Endereco" msprop:Generator_ColumnVarNameInTable="columnEndereco" msprop:Generator_ColumnPropNameInTable="EnderecoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_UserColumnName="Cidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_UserColumnName="Bairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInTable="BairroColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_UserColumnName="Cep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInTable="CepColumn" type="xs:decimal" />
              <xs:element name="UF" msprop:Generator_UserColumnName="UF" msprop:Generator_ColumnPropNameInRow="UF" msprop:Generator_ColumnVarNameInTable="columnUF" msprop:Generator_ColumnPropNameInTable="UFColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_UserColumnName="Telefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fax" msprop:Generator_UserColumnName="Fax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInTable="FaxColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Contato" msprop:Generator_UserColumnName="Contato" msprop:Generator_ColumnPropNameInRow="Contato" msprop:Generator_ColumnVarNameInTable="columnContato" msprop:Generator_ColumnPropNameInTable="ContatoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail" msprop:Generator_UserColumnName="E-mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Site" msprop:Generator_UserColumnName="Site" msprop:Generator_ColumnPropNameInRow="Site" msprop:Generator_ColumnVarNameInTable="columnSite" msprop:Generator_ColumnPropNameInTable="SiteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Funcionario" msprop:Generator_UserTableName="Funcionario" msprop:Generator_RowDeletedName="FuncionarioRowDeleted" msprop:Generator_RowChangedName="FuncionarioRowChanged" msprop:Generator_RowClassName="FuncionarioRow" msprop:Generator_RowChangingName="FuncionarioRowChanging" msprop:Generator_RowEvArgName="FuncionarioRowChangeEvent" msprop:Generator_RowEvHandlerName="FuncionarioRowChangeEventHandler" msprop:Generator_TableClassName="FuncionarioDataTable" msprop:Generator_TableVarName="tableFuncionario" msprop:Generator_RowDeletingName="FuncionarioRowDeleting" msprop:Generator_TablePropName="Funcionario">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Func_ID" msprop:Generator_UserColumnName="Func_ID" msprop:Generator_ColumnPropNameInRow="Func_ID" msprop:Generator_ColumnVarNameInTable="columnFunc_ID" msprop:Generator_ColumnPropNameInTable="Func_IDColumn" type="xs:decimal" />
              <xs:element name="Cargo_ID" msprop:Generator_UserColumnName="Cargo_ID" msprop:Generator_ColumnPropNameInRow="Cargo_ID" msprop:Generator_ColumnVarNameInTable="columnCargo_ID" msprop:Generator_ColumnPropNameInTable="Cargo_IDColumn" type="xs:decimal" />
              <xs:element name="EmpresaID" msprop:Generator_UserColumnName="EmpresaID" msprop:Generator_ColumnPropNameInRow="EmpresaID" msprop:Generator_ColumnVarNameInTable="columnEmpresaID" msprop:Generator_ColumnPropNameInTable="EmpresaIDColumn" type="xs:decimal" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Endereço" msprop:Generator_UserColumnName="Endereço" msprop:Generator_ColumnPropNameInRow="Endereço" msprop:Generator_ColumnVarNameInTable="columnEndereço" msprop:Generator_ColumnPropNameInTable="EndereçoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_UserColumnName="Cidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_UserColumnName="Bairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInTable="BairroColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_UserColumnName="Cep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInTable="CepColumn" type="xs:decimal" />
              <xs:element name="UF" msprop:Generator_UserColumnName="UF" msprop:Generator_ColumnPropNameInRow="UF" msprop:Generator_ColumnVarNameInTable="columnUF" msprop:Generator_ColumnPropNameInTable="UFColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_UserColumnName="Telefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="E-mail" msprop:Generator_UserColumnName="E-mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Status" msprop:Generator_UserTableName="Status" msprop:Generator_RowDeletedName="StatusRowDeleted" msprop:Generator_RowChangedName="StatusRowChanged" msprop:Generator_RowClassName="StatusRow" msprop:Generator_RowChangingName="StatusRowChanging" msprop:Generator_RowEvArgName="StatusRowChangeEvent" msprop:Generator_RowEvHandlerName="StatusRowChangeEventHandler" msprop:Generator_TableClassName="StatusDataTable" msprop:Generator_TableVarName="tableStatus" msprop:Generator_RowDeletingName="StatusRowDeleting" msprop:Generator_TablePropName="Status">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StatusID" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:decimal" />
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Cliente" msprop:Generator_UserTableName="Cliente" msprop:Generator_RowDeletedName="ClienteRowDeleted" msprop:Generator_RowChangedName="ClienteRowChanged" msprop:Generator_RowClassName="ClienteRow" msprop:Generator_RowChangingName="ClienteRowChanging" msprop:Generator_RowEvArgName="ClienteRowChangeEvent" msprop:Generator_RowEvHandlerName="ClienteRowChangeEventHandler" msprop:Generator_TableClassName="ClienteDataTable" msprop:Generator_TableVarName="tableCliente" msprop:Generator_RowDeletingName="ClienteRowDeleting" msprop:Generator_TablePropName="Cliente">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ClienteID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ClienteID" msprop:Generator_ColumnPropNameInRow="ClienteID" msprop:Generator_ColumnVarNameInTable="columnClienteID" msprop:Generator_ColumnPropNameInTable="ClienteIDColumn" type="xs:decimal" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fantasia" msprop:Generator_UserColumnName="Fantasia" msprop:Generator_ColumnPropNameInRow="Fantasia" msprop:Generator_ColumnVarNameInTable="columnFantasia" msprop:Generator_ColumnPropNameInTable="FantasiaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnpj" msprop:Generator_UserColumnName="Cnpj" msprop:Generator_ColumnPropNameInRow="Cnpj" msprop:Generator_ColumnVarNameInTable="columnCnpj" msprop:Generator_ColumnPropNameInTable="CnpjColumn" type="xs:decimal" />
              <xs:element name="Ie" msprop:Generator_UserColumnName="Ie" msprop:Generator_ColumnPropNameInRow="Ie" msprop:Generator_ColumnVarNameInTable="columnIe" msprop:Generator_ColumnPropNameInTable="IeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Endereco" msprop:Generator_UserColumnName="Endereco" msprop:Generator_ColumnPropNameInRow="Endereco" msprop:Generator_ColumnVarNameInTable="columnEndereco" msprop:Generator_ColumnPropNameInTable="EnderecoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_UserColumnName="Cidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_UserColumnName="Bairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInTable="BairroColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_UserColumnName="Cep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInTable="CepColumn" type="xs:decimal" />
              <xs:element name="UF" msprop:Generator_UserColumnName="UF" msprop:Generator_ColumnPropNameInRow="UF" msprop:Generator_ColumnVarNameInTable="columnUF" msprop:Generator_ColumnPropNameInTable="UFColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_UserColumnName="Telefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fax" msprop:Generator_UserColumnName="Fax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInTable="FaxColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Contato" msprop:Generator_UserColumnName="Contato" msprop:Generator_ColumnPropNameInRow="Contato" msprop:Generator_ColumnVarNameInTable="columnContato" msprop:Generator_ColumnPropNameInTable="ContatoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail" msprop:Generator_UserColumnName="E-mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Site" msprop:Generator_UserColumnName="Site" msprop:Generator_ColumnPropNameInRow="Site" msprop:Generator_ColumnVarNameInTable="columnSite" msprop:Generator_ColumnPropNameInTable="SiteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Grupo" msprop:Generator_UserTableName="Grupo" msprop:Generator_RowDeletedName="GrupoRowDeleted" msprop:Generator_RowChangedName="GrupoRowChanged" msprop:Generator_RowClassName="GrupoRow" msprop:Generator_RowChangingName="GrupoRowChanging" msprop:Generator_RowEvArgName="GrupoRowChangeEvent" msprop:Generator_RowEvHandlerName="GrupoRowChangeEventHandler" msprop:Generator_TableClassName="GrupoDataTable" msprop:Generator_TableVarName="tableGrupo" msprop:Generator_RowDeletingName="GrupoRowDeleting" msprop:Generator_TablePropName="Grupo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GrupoID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="GrupoID" msprop:Generator_ColumnVarNameInTable="columnGrupoID" msprop:Generator_ColumnPropNameInRow="GrupoID" msprop:Generator_ColumnPropNameInTable="GrupoIDColumn" type="xs:decimal" />
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SubGrupo" msprop:Generator_UserTableName="SubGrupo" msprop:Generator_RowDeletedName="SubGrupoRowDeleted" msprop:Generator_RowChangedName="SubGrupoRowChanged" msprop:Generator_RowClassName="SubGrupoRow" msprop:Generator_RowChangingName="SubGrupoRowChanging" msprop:Generator_RowEvArgName="SubGrupoRowChangeEvent" msprop:Generator_RowEvHandlerName="SubGrupoRowChangeEventHandler" msprop:Generator_TableClassName="SubGrupoDataTable" msprop:Generator_TableVarName="tableSubGrupo" msprop:Generator_RowDeletingName="SubGrupoRowDeleting" msprop:Generator_TablePropName="SubGrupo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="subGrupoID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="subGrupoID" msprop:Generator_ColumnVarNameInTable="columnsubGrupoID" msprop:Generator_ColumnPropNameInRow="subGrupoID" msprop:Generator_ColumnPropNameInTable="subGrupoIDColumn" type="xs:decimal" />
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Unidade_Medida" msprop:Generator_UserTableName="Unidade_Medida" msprop:Generator_RowDeletedName="Unidade_MedidaRowDeleted" msprop:Generator_RowChangedName="Unidade_MedidaRowChanged" msprop:Generator_RowClassName="Unidade_MedidaRow" msprop:Generator_RowChangingName="Unidade_MedidaRowChanging" msprop:Generator_RowEvArgName="Unidade_MedidaRowChangeEvent" msprop:Generator_RowEvHandlerName="Unidade_MedidaRowChangeEventHandler" msprop:Generator_TableClassName="Unidade_MedidaDataTable" msprop:Generator_TableVarName="tableUnidade_Medida" msprop:Generator_RowDeletingName="Unidade_MedidaRowDeleting" msprop:Generator_TablePropName="Unidade_Medida">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UniMedidaID" msprop:Generator_UserColumnName="UniMedidaID" msprop:Generator_ColumnPropNameInRow="UniMedidaID" msprop:Generator_ColumnVarNameInTable="columnUniMedidaID" msprop:Generator_ColumnPropNameInTable="UniMedidaIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Produto" msprop:Generator_UserTableName="Produto" msprop:Generator_RowDeletedName="ProdutoRowDeleted" msprop:Generator_TableClassName="ProdutoDataTable" msprop:Generator_RowChangedName="ProdutoRowChanged" msprop:Generator_RowClassName="ProdutoRow" msprop:Generator_RowChangingName="ProdutoRowChanging" msprop:Generator_RowEvArgName="ProdutoRowChangeEvent" msprop:Generator_RowEvHandlerName="ProdutoRowChangeEventHandler" msprop:Generator_TablePropName="Produto" msprop:Generator_TableVarName="tableProduto" msprop:Generator_RowDeletingName="ProdutoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProdutoID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ProdutoID" msprop:Generator_ColumnPropNameInRow="ProdutoID" msprop:Generator_ColumnVarNameInTable="columnProdutoID" msprop:Generator_ColumnPropNameInTable="ProdutoIDColumn" type="xs:decimal" />
              <xs:element name="Codigo_Barras" msprop:Generator_UserColumnName="Codigo_Barras" msprop:Generator_ColumnPropNameInRow="Codigo_Barras" msprop:Generator_ColumnVarNameInTable="columnCodigo_Barras" msprop:Generator_ColumnPropNameInTable="Codigo_BarrasColumn" type="xs:decimal" />
              <xs:element name="GrupoID" msprop:Generator_UserColumnName="GrupoID" msprop:Generator_ColumnPropNameInRow="GrupoID" msprop:Generator_ColumnVarNameInTable="columnGrupoID" msprop:Generator_ColumnPropNameInTable="GrupoIDColumn" type="xs:decimal" />
              <xs:element name="subGrupoID" msprop:Generator_UserColumnName="subGrupoID" msprop:Generator_ColumnPropNameInRow="subGrupoID" msprop:Generator_ColumnVarNameInTable="columnsubGrupoID" msprop:Generator_ColumnPropNameInTable="subGrupoIDColumn" type="xs:decimal" />
              <xs:element name="UniMedidaID" msprop:Generator_UserColumnName="UniMedidaID" msprop:Generator_ColumnPropNameInRow="UniMedidaID" msprop:Generator_ColumnVarNameInTable="columnUniMedidaID" msprop:Generator_ColumnPropNameInTable="UniMedidaIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Qtde" msprop:Generator_UserColumnName="Qtde" msprop:Generator_ColumnPropNameInRow="Qtde" msprop:Generator_ColumnVarNameInTable="columnQtde" msprop:Generator_ColumnPropNameInTable="QtdeColumn" type="xs:decimal" />
              <xs:element name="Estoque_Minimo" msprop:Generator_UserColumnName="Estoque_Minimo" msprop:Generator_ColumnPropNameInRow="Estoque_Minimo" msprop:Generator_ColumnVarNameInTable="columnEstoque_Minimo" msprop:Generator_ColumnPropNameInTable="Estoque_MinimoColumn" type="xs:decimal" />
              <xs:element name="precoCusto" msprop:Generator_UserColumnName="precoCusto" msprop:Generator_ColumnPropNameInRow="precoCusto" msprop:Generator_ColumnVarNameInTable="columnprecoCusto" msprop:Generator_ColumnPropNameInTable="precoCustoColumn" type="xs:decimal" />
              <xs:element name="precoVenda" msprop:Generator_UserColumnName="precoVenda" msprop:Generator_ColumnPropNameInRow="precoVenda" msprop:Generator_ColumnVarNameInTable="columnprecoVenda" msprop:Generator_ColumnPropNameInTable="precoVendaColumn" type="xs:decimal" />
              <xs:element name="EmpresaID" msprop:Generator_UserColumnName="EmpresaID" msprop:Generator_ColumnPropNameInRow="EmpresaID" msprop:Generator_ColumnVarNameInTable="columnEmpresaID" msprop:Generator_ColumnPropNameInTable="EmpresaIDColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Empresa" msprop:Generator_UserTableName="Empresa" msprop:Generator_RowDeletedName="EmpresaRowDeleted" msprop:Generator_TableClassName="EmpresaDataTable" msprop:Generator_RowChangedName="EmpresaRowChanged" msprop:Generator_RowClassName="EmpresaRow" msprop:Generator_RowChangingName="EmpresaRowChanging" msprop:Generator_RowEvArgName="EmpresaRowChangeEvent" msprop:Generator_RowEvHandlerName="EmpresaRowChangeEventHandler" msprop:Generator_TablePropName="Empresa" msprop:Generator_TableVarName="tableEmpresa" msprop:Generator_RowDeletingName="EmpresaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmpresaID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="EmpresaID" msprop:Generator_ColumnPropNameInRow="EmpresaID" msprop:Generator_ColumnVarNameInTable="columnEmpresaID" msprop:Generator_ColumnPropNameInTable="EmpresaIDColumn" type="xs:decimal" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fantasia" msprop:Generator_UserColumnName="Fantasia" msprop:Generator_ColumnPropNameInRow="Fantasia" msprop:Generator_ColumnVarNameInTable="columnFantasia" msprop:Generator_ColumnPropNameInTable="FantasiaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnpj" msprop:Generator_UserColumnName="Cnpj" msprop:Generator_ColumnPropNameInRow="Cnpj" msprop:Generator_ColumnVarNameInTable="columnCnpj" msprop:Generator_ColumnPropNameInTable="CnpjColumn" type="xs:decimal" />
              <xs:element name="Ie" msprop:Generator_UserColumnName="Ie" msprop:Generator_ColumnPropNameInRow="Ie" msprop:Generator_ColumnVarNameInTable="columnIe" msprop:Generator_ColumnPropNameInTable="IeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Endereco" msprop:Generator_UserColumnName="Endereco" msprop:Generator_ColumnPropNameInRow="Endereco" msprop:Generator_ColumnVarNameInTable="columnEndereco" msprop:Generator_ColumnPropNameInTable="EnderecoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_UserColumnName="Cidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_UserColumnName="Bairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInTable="BairroColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_UserColumnName="Cep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInTable="CepColumn" type="xs:decimal" />
              <xs:element name="UF" msprop:Generator_UserColumnName="UF" msprop:Generator_ColumnPropNameInRow="UF" msprop:Generator_ColumnVarNameInTable="columnUF" msprop:Generator_ColumnPropNameInTable="UFColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_UserColumnName="Telefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fax" msprop:Generator_UserColumnName="Fax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInTable="FaxColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="E-mail" msprop:Generator_UserColumnName="E-mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Site" msprop:Generator_UserColumnName="Site" msprop:Generator_ColumnPropNameInRow="Site" msprop:Generator_ColumnVarNameInTable="columnSite" msprop:Generator_ColumnPropNameInTable="SiteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cargo_Funcionario" />
      <xs:field xpath="mstns:Cargo_ID" />
    </xs:unique>
    <xs:unique name="Comanda_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Comanda" />
      <xs:field xpath="mstns:ComandaID" />
    </xs:unique>
    <xs:unique name="Estado_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Estado" />
      <xs:field xpath="mstns:Sigla" />
    </xs:unique>
    <xs:unique name="Formas_Pagamento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Formas_Pagamento" />
      <xs:field xpath="mstns:FormasPagID" />
    </xs:unique>
    <xs:unique name="Fornecedor_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Fornecedor" />
      <xs:field xpath="mstns:FornecedorID" />
    </xs:unique>
    <xs:unique name="Funcionario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Funcionario" />
      <xs:field xpath="mstns:Func_ID" />
    </xs:unique>
    <xs:unique name="Status_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Status" />
      <xs:field xpath="mstns:StatusID" />
    </xs:unique>
    <xs:unique name="Cliente_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cliente" />
      <xs:field xpath="mstns:ClienteID" />
    </xs:unique>
    <xs:unique name="Grupo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Grupo" />
      <xs:field xpath="mstns:GrupoID" />
    </xs:unique>
    <xs:unique name="SubGrupo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SubGrupo" />
      <xs:field xpath="mstns:subGrupoID" />
    </xs:unique>
    <xs:unique name="Unidade_Medida_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Unidade_Medida" />
      <xs:field xpath="mstns:UniMedidaID" />
    </xs:unique>
    <xs:unique name="Produto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Produto" />
      <xs:field xpath="mstns:ProdutoID" />
    </xs:unique>
    <xs:unique name="Empresa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Empresa" />
      <xs:field xpath="mstns:EmpresaID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK__Comanda__StatusI__2A4B4B5E" msdata:parent="Status" msdata:child="Comanda" msdata:parentkey="StatusID" msdata:childkey="StatusID" msprop:Generator_UserRelationName="FK__Comanda__StatusI__2A4B4B5E" msprop:Generator_RelationVarName="relationFK__Comanda__StatusI__2A4B4B5E" msprop:Generator_UserChildTable="Comanda" msprop:Generator_UserParentTable="Status" msprop:Generator_ParentPropName="StatusRow" msprop:Generator_ChildPropName="GetComandaRows" />
      <msdata:Relationship name="FK__Funcionar__Cargo__276EDEB3" msdata:parent="Cargo_Funcionario" msdata:child="Funcionario" msdata:parentkey="Cargo_ID" msdata:childkey="Cargo_ID" msprop:Generator_UserRelationName="FK__Funcionar__Cargo__276EDEB3" msprop:Generator_RelationVarName="relationFK__Funcionar__Cargo__276EDEB3" msprop:Generator_UserChildTable="Funcionario" msprop:Generator_UserParentTable="Cargo_Funcionario" msprop:Generator_ParentPropName="Cargo_FuncionarioRow" msprop:Generator_ChildPropName="GetFuncionarioRows" />
      <msdata:Relationship name="FK__Produto__GrupoID__2B3F6F97" msdata:parent="Grupo" msdata:child="Produto" msdata:parentkey="GrupoID" msdata:childkey="GrupoID" msprop:Generator_UserRelationName="FK__Produto__GrupoID__2B3F6F97" msprop:Generator_RelationVarName="relationFK__Produto__GrupoID__2B3F6F97" msprop:Generator_UserChildTable="Produto" msprop:Generator_UserParentTable="Grupo" msprop:Generator_ParentPropName="GrupoRow" msprop:Generator_ChildPropName="GetProdutoRows" />
      <msdata:Relationship name="FK__Produto__subGrup__2C3393D0" msdata:parent="SubGrupo" msdata:child="Produto" msdata:parentkey="subGrupoID" msdata:childkey="subGrupoID" msprop:Generator_UserRelationName="FK__Produto__subGrup__2C3393D0" msprop:Generator_RelationVarName="relationFK__Produto__subGrup__2C3393D0" msprop:Generator_UserChildTable="Produto" msprop:Generator_UserParentTable="SubGrupo" msprop:Generator_ParentPropName="SubGrupoRow" msprop:Generator_ChildPropName="GetProdutoRows" />
      <msdata:Relationship name="FK__Produto__UniMedi__2D27B809" msdata:parent="Unidade_Medida" msdata:child="Produto" msdata:parentkey="UniMedidaID" msdata:childkey="UniMedidaID" msprop:Generator_UserRelationName="FK__Produto__UniMedi__2D27B809" msprop:Generator_RelationVarName="relationFK__Produto__UniMedi__2D27B809" msprop:Generator_UserChildTable="Produto" msprop:Generator_UserParentTable="Unidade_Medida" msprop:Generator_ParentPropName="Unidade_MedidaRow" msprop:Generator_ChildPropName="GetProdutoRows" />
      <msdata:Relationship name="FK__Funcionar__Empre__286302EC" msdata:parent="Empresa" msdata:child="Funcionario" msdata:parentkey="EmpresaID" msdata:childkey="EmpresaID" msprop:Generator_UserRelationName="FK__Funcionar__Empre__286302EC" msprop:Generator_RelationVarName="relationFK__Funcionar__Empre__286302EC" msprop:Generator_UserChildTable="Funcionario" msprop:Generator_UserParentTable="Empresa" msprop:Generator_ParentPropName="EmpresaRow" msprop:Generator_ChildPropName="GetFuncionarioRows" />
      <msdata:Relationship name="FK__Produto__Empresa__29572725" msdata:parent="Empresa" msdata:child="Produto" msdata:parentkey="EmpresaID" msdata:childkey="EmpresaID" msprop:Generator_UserRelationName="FK__Produto__Empresa__29572725" msprop:Generator_RelationVarName="relationFK__Produto__Empresa__29572725" msprop:Generator_UserChildTable="Produto" msprop:Generator_UserParentTable="Empresa" msprop:Generator_ParentPropName="EmpresaRow" msprop:Generator_ChildPropName="GetProdutoRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>